﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'UpdateLogServicioByIdInsumo')
	BEGIN
		DROP  Procedure  UpdateLogServicioByIdInsumo
	END

GO

CREATE Procedure UpdateLogServicioByIdInsumo

	(
		@IdInsumo smallint,
		@IdEstado int
	)

AS
BEGIN

	UPDATE LogServicio SET IdEstado = @IdEstado WHERE IdInsumo = @IdInsumo

END

GO


GRANT EXEC ON UpdateLogServicioByIdInsumo TO PUBLIC

GO


